Postgres Pro
Downloads
Home   >   mailing lists

Re: no self-joins in views? - Mailing list pgsql-general

From Christoph Pingel
Subject Re: no self-joins in views?
Date
Msg-id a06100505be315ac7926c@[62.224.56.43]
Whole thread Raw
In response to Re: no self-joins in views?  (Richard Huxton <dev@archonet.com>)
Responses Re: no self-joins in views? - works now!  (Christoph Pingel <ch.pingel@web.de>)
List pgsql-general
Tree view 
>You've got two columns that the system wants to call "obj_id" here.
>Try something like
>   SELECT s.obj_id AS s_obj_id, ...

That would have been elegant, but returns a 'syntax error at or near
"s_obj_id"'. Hm...

Thanks,
Christoph

pgsql-general by date:

Previous
From: Christoph Pingel
Date:
Subject: Re: no self-joins in views?
Next
From: James Thompson
Date:
Subject: Re: Python Interface